Excel Reporting Strategies: A Quick & Easy Guide to Report Integration & Manipulation by Chelsea Bloomfield Eckley

Author:Chelsea Bloomfield Eckley [Bloomfield Eckley, Chelsea]
Language: eng
Format: epub
Publisher: UNKNOWN
Published: 2016-09-29T07:00:00+00:00

Tips:

Quotation marks must be used for non-numerical values

Pay attention to the color of the parenthesis in Excel. The color helps identify, which IF STATEMENT the parenthesis is encompassing.

Diagram 5.3: Nested IF Statements by Color

=IF(E2="Apples","RED","FALSE")

=IF(E3="Apples", "RED", IF(E3="Honey", "YELLOW","FALSE"))

=IF(E4="Apples", "RED", IF(E4="Honey", "YELLOW", IF(E4="Zucchini", "GREEN", "FALSE")))

=IF(E5="Apples", "RED", IF(E5="Honey", "YELLOW", IF(E5="Zucchini", "GREEN", IF(E5="Eggs", "WHITE", "FALSE"))))

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.